package jpa.entitys.promis.common;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the VW_SYNC_DEPOSIT_RENTAL_RETURN database table.
 * 
 */
@Entity
@Table(name="VW_SYNC_DEPOS_RENT_RETURN")
@NamedQueries({
    @NamedQuery(name = "VwSyncDepositRentalReturn.findAll", query = " SELECT c FROM VwSyncDepositRentalReturn c "),
    @NamedQuery(name = "VwSyncDepositRentalReturn.findById", query = " SELECT c FROM VwSyncDepositRentalReturn c WHERE c.depositReturnDetailsId = :Id "),
    @NamedQuery(name = "VwSyncDepositRentalReturn.findByStatus", query = " SELECT c FROM VwSyncDepositRentalReturn c WHERE c.postingStatus = :status And c.syncIsstaging = :syncIsstaging "),
    @NamedQuery(name = "VwSyncDepositRentalReturn.findByDocumentNo", query = " SELECT c FROM VwSyncDepositRentalReturn c WHERE c.company = :company And c.project =:project And c.documentNo = :documentNo And c.postingStatus = :status And c.syncIsstaging = :syncIsstaging")
})
public class VwSyncDepositRentalReturn extends jpa.entitys.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="DEPOSIT_RETURN_DETAILS_ID")
	private String depositReturnDetailsId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}
	
	@Column(name="AMOUNT_ADJUSTED")
	private BigDecimal amountAdjusted;

	@Column(name="AP_REFERENCE_NUMBER")
	private BigDecimal apReferenceNumber;

	@Column(name="AP_REFERENCE_SERIES")
	private String apReferenceSeries;

	@Column(name="AP_REFERENCE_VOUCHER_TYPE")
	private String apReferenceVoucherType;

	@Column(name="CHARGE_CODE")
	private String chargeCode;

	@Column(nullable=false)
	private String company;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_BY_NAME")
	private String createdByName;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="CREATED_ON")
	private Date createdOn;

	@Column(length=3)
	private String currency;

	@Column(length=4000)
	private String description;

	@Column(name="EXCHANGE_RATE")
	private BigDecimal exchangeRate;

	@Column(name="INTERFACE_NO")
	private String interfaceNo;

	@Column(name="LAST_UPD_BY")
	private String lastUpdBy;

	@Column(name="LAST_UPD_BY_NAME")
	private String lastUpdByName;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="LAST_UPD_ON")
	private Date lastUpdOn;

	@Column(length=2000)
	private String narration;

	@Column(name="PAYMENT_VOUCHERS_ID")
	private String paymentVouchersId;

	@Column(name="POSTING_STATUS")
	private String postingStatus;

	@Column(length=30)
	private String project;

	@Column(name="REF_CONTRACT_NO")
	private String refContractNo;

	@Column(name="REF_INV_NO")
	private String refInvNo;

	@Column(name="SAP_COMPANY_CODE")
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE")
	private String sapPlantCode;

	@Column(name="SEQ_NO")
	private BigDecimal seqNo;

	@Column(name="SUPPLIER_CODE")
	private String supplierCode;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_EXTERNAL_REF_KEY")
	private String syncExternalRefKey;

	@Column(name="SYNC_EXTERNAL_REF_NO")
	private String syncExternalRefNo;

	@Column(name="SYNC_ISSTAGING")
	private String syncIsstaging;

	@Column(name="SYNC_ISSYNC")
	private String syncIssync;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="VAT_AMOUNT")
	private BigDecimal vatAmount;

	@Column(name="VAT_BASE_AMOUNT")
	private BigDecimal vatBaseAmount;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="VOUCHER_DATE")
	private Date voucherDate;

	@Column(name="VOUCHER_NUMBER")
	private long voucherNumber;

	@Column(name="VOUCHER_SERIES")
	private String voucherSeries;

	@Column(name="VOUCHER_TYPE")
	private String voucherType;
	
	@Column(name="DOCUMENT_NO")
	private String documentNo;
	
	@Column(name="STATUS")
	private String status;
	
	@Column(name="SYNC_PK_ID")
	private String syncPkId;
		
	@Column(name="NET_AMOUNT_ADJUSTED")
	private BigDecimal netAmountAdjusted;
	
	@Column(name="REF_TAX_DOCUMENT")
	private String refTaxDocument;
	
    public BigDecimal getNetAmountAdjusted() {
		return netAmountAdjusted;
	}

	public void setNetAmountAdjusted(BigDecimal netAmountAdjusted) {
		this.netAmountAdjusted = netAmountAdjusted;
	}

	public String getRefTaxDocument() {
		return refTaxDocument;
	}

	public void setRefTaxDocument(String refTaxDocument) {
		this.refTaxDocument = refTaxDocument;
	}

	/**
	 * @return the syncPkId
	 */
	public String getSyncPkId() {
		return syncPkId;
	}

	/**
	 * @param syncPkId the syncPkId to set
	 */
	public void setSyncPkId(String syncPkId) {
		this.syncPkId = syncPkId;
	}

	/**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}

	/**
	 * @return the documentNo
	 */
	public String getDocumentNo() {
		return documentNo;
	}

	/**
	 * @param documentNo the documentNo to set
	 */
	public void setDocumentNo(String documentNo) {
		this.documentNo = documentNo;
	}

    public VwSyncDepositRentalReturn() {
    }

	public BigDecimal getAmountAdjusted() {
		return this.amountAdjusted;
	}

	public void setAmountAdjusted(BigDecimal amountAdjusted) {
		this.amountAdjusted = amountAdjusted;
	}

	public BigDecimal getApReferenceNumber() {
		return this.apReferenceNumber;
	}

	public void setApReferenceNumber(BigDecimal apReferenceNumber) {
		this.apReferenceNumber = apReferenceNumber;
	}

	public String getApReferenceSeries() {
		return this.apReferenceSeries;
	}

	public void setApReferenceSeries(String apReferenceSeries) {
		this.apReferenceSeries = apReferenceSeries;
	}

	public String getApReferenceVoucherType() {
		return this.apReferenceVoucherType;
	}

	public void setApReferenceVoucherType(String apReferenceVoucherType) {
		this.apReferenceVoucherType = apReferenceVoucherType;
	}

	public String getChargeCode() {
		return this.chargeCode;
	}

	public void setChargeCode(String chargeCode) {
		this.chargeCode = chargeCode;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedByName() {
		return this.createdByName;
	}

	public void setCreatedByName(String createdByName) {
		this.createdByName = createdByName;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getDepositReturnDetailsId() {
		return this.depositReturnDetailsId;
	}

	public void setDepositReturnDetailsId(String depositReturnDetailsId) {
		this.depositReturnDetailsId = depositReturnDetailsId;
	}

	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public BigDecimal getExchangeRate() {
		return this.exchangeRate;
	}

	public void setExchangeRate(BigDecimal exchangeRate) {
		this.exchangeRate = exchangeRate;
	}

	public String getInterfaceNo() {
		return this.interfaceNo;
	}

	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}

	public String getLastUpdBy() {
		return this.lastUpdBy;
	}

	public void setLastUpdBy(String lastUpdBy) {
		this.lastUpdBy = lastUpdBy;
	}

	public String getLastUpdByName() {
		return this.lastUpdByName;
	}

	public void setLastUpdByName(String lastUpdByName) {
		this.lastUpdByName = lastUpdByName;
	}

	public Date getLastUpdOn() {
		return this.lastUpdOn;
	}

	public void setLastUpdOn(Date lastUpdOn) {
		this.lastUpdOn = lastUpdOn;
	}

	public String getNarration() {
		return this.narration;
	}

	public void setNarration(String narration) {
		this.narration = narration;
	}

	public String getPaymentVouchersId() {
		return this.paymentVouchersId;
	}

	public void setPaymentVouchersId(String paymentVouchersId) {
		this.paymentVouchersId = paymentVouchersId;
	}

	public String getPostingStatus() {
		return this.postingStatus;
	}

	public void setPostingStatus(String postingStatus) {
		this.postingStatus = postingStatus;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getRefContractNo() {
		return this.refContractNo;
	}

	public void setRefContractNo(String refContractNo) {
		this.refContractNo = refContractNo;
	}

	public String getRefInvNo() {
		return this.refInvNo;
	}

	public void setRefInvNo(String refInvNo) {
		this.refInvNo = refInvNo;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public BigDecimal getSeqNo() {
		return this.seqNo;
	}

	public void setSeqNo(BigDecimal seqNo) {
		this.seqNo = seqNo;
	}

	public String getSupplierCode() {
		return this.supplierCode;
	}

	public void setSupplierCode(String supplierCode) {
		this.supplierCode = supplierCode;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncExternalRefKey() {
		return this.syncExternalRefKey;
	}

	public void setSyncExternalRefKey(String syncExternalRefKey) {
		this.syncExternalRefKey = syncExternalRefKey;
	}

	public String getSyncExternalRefNo() {
		return this.syncExternalRefNo;
	}

	public void setSyncExternalRefNo(String syncExternalRefNo) {
		this.syncExternalRefNo = syncExternalRefNo;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncIssync() {
		return this.syncIssync;
	}

	public void setSyncIssync(String syncIssync) {
		this.syncIssync = syncIssync;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public BigDecimal getVatAmount() {
		return this.vatAmount;
	}

	public void setVatAmount(BigDecimal vatAmount) {
		this.vatAmount = vatAmount;
	}

	public BigDecimal getVatBaseAmount() {
		return this.vatBaseAmount;
	}

	public void setVatBaseAmount(BigDecimal vatBaseAmount) {
		this.vatBaseAmount = vatBaseAmount;
	}

	public Date getVoucherDate() {
		return this.voucherDate;
	}

	public void setVoucherDate(Date voucherDate) {
		this.voucherDate = voucherDate;
	}
 

	public long getVoucherNumber() {
		return this.voucherNumber;
	}

	public void setVoucherNumber(long voucherNumber) {
		this.voucherNumber = voucherNumber;
	}

	public String getVoucherSeries() {
		return this.voucherSeries;
	}

	public void setVoucherSeries(String voucherSeries) {
		this.voucherSeries = voucherSeries;
	}

	public String getVoucherType() {
		return this.voucherType;
	}

	public void setVoucherType(String voucherType) {
		this.voucherType = voucherType;
	}

}